package com.woniu.mapper;

import com.woniu.entity.Staff;
import com.woniu.vo.StaffVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author FQY
* @description 针对表【staff(员工表)】的数据库操作Mapper
* @createDate 2025-10-30 15:14:40
* @Entity com.woniu.entity.Staff
*/
public interface StaffMapper {

    Integer deleteByPrimaryKey(Integer id);

    Integer insert(Staff record);

    Integer insertSelective(Staff record);

    Staff selectByPrimaryKey(Integer id);

    Integer updateByPrimaryKeySelective(Staff record);

    Integer updateByPrimaryKey(Staff record);
    List<Staff> selectAll();
    Integer updateStaff(Integer id);
    List<Staff> selectByCondition(
            @Param("name")     String name,
            @Param("deptName") String deptName,
            @Param("roomName") String roomName);

    List<StaffVO> selectVoAll();

    List<StaffVO> selectVoByCondition(@Param("name") String name,
                                      @Param("deptName") String deptName,
                                      @Param("roomName") String roomName);

    Staff findByNo(String staffNo);

    List<Staff> findAll();

}
